ANCLIN STEPHY.J
2 0 2 4
ASPIRING DATA ANALYST
Analytical and results-oriented Data Analyst with a robust skill
set in data extraction, transformation, and visualization.
Proficient in SQL, Python, Power BI, Excel, and Tableau, with
hands-on experience in handling complex data sets and
deriving actionable insights to drive informed decision-making.
Skilled in creating interactive dashboards and visualizations in
Power BI and Tableau, enabling clear and impactful data
storytelling for stakeholders. Known for strong analytical
thinking, statistical analysis, and communication abilities,
translating complex findings into digestible insights for both
technical and non-technical audiences.
EDUCATION DETAILS
Degree: Bachelor of Computer Science
Institution: Infant Jesus College of Arts and Science for Women
Location: Mulagumoodu, Kanyakumari, Tamil Nadu
Affiliated University: Manonmaniam Sundaranar University, Tirunelveli
Graduation Year: 2024
Cgpa:8.08
PROFESSIONAL DATA ANALYST TRAINING
Completed a Data Analytics course at Besant Technologies in Electronic City,
Bangalore.
Completed SQL and Python courses at Besant Technologies in Electronic City,
Bangalore.
CERTIFICATIONS
Diploma in Computer Application Certified by TCEDS
Desktop Publishing Certified by CSC Academy
Data analytics 5 days workshop Certified by Jobajlearnings
Data analytics using power BI Certified by Naan Mudhalvan
DATA ANALYSIS SKILLS
Data Modeling
Data Wrangling
Data Collection
Data Cleaning
Data Blending
Data Manipulation
EDA
DATA INSIGHTS & MANAGEMENT
Data Visualization
Dashboard Creation
Database Management
KPI Tracking Reporting
Data Governance
Data Transformation
TECHNICAL TOOLS & TECHNIQUES
Pivot Tables
Advanced Excel
Power BI
Tableau
SQL
Python
SQL Queries
Python Libraries
Macros
Power Query
ETL (Extract,
Transform,Load)
Data Mining
Data Warehousing
SOFT SKILLS
Time Management
Leadership
Communication
Analytical Thinking
Problem-Solving
Attention to Detail
Critical Thinking
PROJECT OVERVIEW
Sales Data Excel Dashboard:
Designed and developed a comprehensive Excel sales dashboard that effectively visualizes
critical sales data. The dashboard provides insights into unit sales by system, sales amounts by
region, and individual sales performance metrics. Utilizing a variety of visualization techniques,
including bar charts, pie charts, and line graphs, I presented complex data clearly and
engagingly. This facilitated data-driven decision-making and improved the team’s ability to
monitor regional trends and individual sales performance.
To enhance usability, I incorporated interactive elements such as drop-down menus and slicers,
allowing users to filter data by specific criteria and timeframes. Additionally, I integrated key
performance indicators (KPIs) for quick access to critical metrics and ensured real-time data
updates through Excel's Power Query. This project streamlined reporting processes, reduced
manual analysis time, and empowered the sales team to make informed, strategic decisions
based on accurate insights.
Module 2: Pivot Tables and Charts
Create Pivot Tables: Summarize data easily.
Analyze Trends: Find patterns in your data.
Make Charts: Visualize data using charts.
Design Dashboard: Organize your dashboard for better viewing.
Module 3: Advanced Visualization
Custom Charts: Make different types of charts for clarity.
Interactive Features: Add buttons and filters for user interaction.
Design Tips: Use good colors and layouts for easy reading.
Update Data: Refresh your dashboard with the latest information.
Module 1: Data Collection
Find Data: Learn where to get data from files, databases, and online sources.
Import Data: Use Excel tools to bring data into your spreadsheet.
Clean Data: Remove errors and format data correctly.
Organize Data: Structure data for easy analysis.
Zomato Analytical PowerBI Dashboard:
The Zomato Restaurant Analytical Dashboard in Power BI provides valuable insights into
customer ratings, online delivery, and table delivery performance. Utilizing interactive
visualizations, the dashboard highlights key trends and metrics that are crucial for
understanding customer preferences and operational efficiency. Features such as dynamic
charts, heat maps, and filters allow restaurant managers to analyze data at a glance, making it
easier to identify areas for improvement and track performance over time.
This dashboard enables restaurant managers to optimize operations and enhance customer
experiences by providing actionable insights. Key metrics, including average delivery times,
customer feedback scores, and order volumes, help managers understand their service
performance. Additionally, the dashboard facilitates comparative analysis by allowing users to
view trends across different time periods and restaurant locations. By tracking these
performance indicators, restaurant managers can implement targeted strategies to improve
service quality, enhance menu offerings, and respond proactively to customer feedback.
Ultimately, this analytical tool empowers restaurants to adapt to changing customer needs,
streamline operations, and stay competitive in the market.
TModule 1: Data Collection
Understanding Data Sources: Learn to identify and access various data sources, such as
surveys, databases, and online resources.
Importing Data: Discover how to import data into Excel from different formats, including CSV,
Excel files, and web sources.
Data Organization: Understand best practices for organizing and structuring collected data
for easier analysis.
Module 2: Data Cleaning
Identifying Errors: Learn how to spot common data quality issues, such as duplicates, missing
values, and formatting inconsistencies.
Data Correction Techniques: Explore methods to clean and correct data, including removing
duplicates, filling in missing values, and standardizing formats.
Using Excel Tools: Gain hands-on experience with Excel functions and tools like Find &
Replace, Data Validation, and Conditional Formatting to streamline the cleaning process.
Module 3: Data Visualization
Choosing Visualization Types: Understand how to select the right type of chart or graph
based on the data being presented.
Creating Charts in Excel: Learn how to create various visualizations, such as bar charts, line
graphs, and pie charts, to effectively communicate data insights.
Building Dashboards: Discover how to compile visualizations into a cohesive dashboard,
using interactivity and design principles to enhance user experience.
